Qid Examcode Question Qimpath opt1 opt2 opt3 opt4 opt5 opt6 opt7 opt8 opt9 opt10 opt11 opt12 opt13 opt14 opt15 impath1 impath2 impath3 impath4 impath5 impath6 impath7 impath8 impath9 impath10 impath11 impath12 impath13 impath14 impath15 answers uanswer CR Edit Delete
150 1Z0-048 View the Exhibit, which displays the cluster database performance page after the same workload has been executed three times on your cluster without varying any non-Oracle workloads on the cluster. What are the two ways by which you can tell that the corresponding application was better tuned during the second and third execution? (Choose two.) There is less paging each time The run queue length is going down each time. It takes less time to execute the workload each time. The number of transactions per second is getting higher each time. The database throughout graphic is below the red dashed line during the last execution. 3, 4 MC edit delete
149 1Z0-048 According to the Maximum Availability Architecture, which case is best? Run two identical sites with a primary RAC database on the first site, and only a RAC logical standby database on the second site. Run two identical sites with a primary RAC database on the first site, and only a RAC physical standby database on the second site. Run two identical sites with a primary RAC database on the first site, and RAC physical and logical standby databases on the second site. Run two identical sites with a primary RAC database on the first site, and non-RAC physical and logical standby databases on the second site. 3 SC edit delete
148 1Z0-048 Your storage administrator informs you about some disk corruption issues in the disk subsystem where your Oracle Cluster Registry (OCR) backups are located. Your storage administrator has resolved these corruption issues by applying a patch to the storage subsystem, but to be sure that the OCR backups are not affected by this problem the administrator wants you to check the integrity of the OCR backups. How would you do this? There is no easy way to check your OCR backups for corruptions. You can check whether the OCR backups are not corrupted by using the OCRCHECK command. You create a logical export from the OCR backups by using the OCRCONFIG command and analyze the export file for errors. You dump the OCR backup contents into a text file by using the OCRDUMP command, and if that succeeds without errors you know that your OCR backups are not corrupted. You create another physical backup of the OCR backups by using the OCRCONFIG command, and if this succeeds without errors you know that the OCR backups are not corrupted. 4 SC edit delete
147 1Z0-048 In a RAC environment, you see a steep increase for enq:HW - contention and gc current grant wait events. What would you do to fix this issue? Increase the cache size of sequences. Reduce the time of transactions by committing more often. Use larger uniform extent sizes for objects. Reduce the number of updates causing locks on tables accessed by multiple instances. 3 SC edit delete
146 1Z0-048 You have a three-tier architecture for your application, which uses an Oracle RAC database and a middle tier that uses Oracle Application Server with Java programming, using JDBC as the standard. There are three RAC services defined, and four instances in the database are using ASM as the cluster file system. Connection pools are also used. Which three features of Fast Application Notification would be beneficial in your environment, and which choices for your application would you recommend? (Choose three.) ODP.Net connection pool JDBC Implicit Connection Cache the App Server Up and Down FAN event notifications the continuous availability of services due to FAN events Load Balancing Advisory FAN events to control ASM I/O workload Load Balancing Advisory FAN events to control workload per instance for each service 2, 4, 6 MC edit delete
145 1Z0-048 Which two statements are true in any RAC environment? (Choose two.) After your redo threads are defined, you cannot add new ones. A RAC database must contain at least two threads of redo log files per instance. A RAC database must contain at most one redo thread for each instance. A publicly enabled thread can be used by any instance of your RAC database. A redo thread must contain at least two groups of redo log files before it can be enabled. 4, 5 MC edit delete
144 1Z0-048 You decide to implement Fast Start Failover for your RAC Data Guard configuration to improve your high availability strategy. Which are the two valid locations for the DG Broker configuration files? (Choose two.) on the local storage at the observer location on the shared storage at the primary location on the shared storage at the standby location on the shared storage at the observer location on the storage that is shared between the observer location and at least one of the instances that is part of the data guard configuration 2, 3 MC edit delete
143 1Z0-048 You are working with Oracle Support to resolve an issue regarding the Oracle Clusterware software. The Oracle support engineer wants you to upload all relevant CRS log and trace files. How would you provide all the requested log and trace files? Upload each and every available log and trace files to Oracle Support. Use Grid Control to collect and send all required log and trace files to Oracle Support. Collect all required log and trace files using the diagcollection.pl command and upload them to Oracle Support. Use an operating system command to create an archive with all the log and trace files stored in the ORA_CRS_HOME/log directory and upload the files to Oracle Support. 3 SC edit delete
142 1Z0-048 What is the action of your client connection when it is using the following connect string? 142-qracm.png It always connects you to the least loaded node. It always connects you to the first protocol address. It randomizes its connection on the available listeners. It tries to connect you to the listener on SALES2-SRV-VIP if the listener on SALES1-SRV-VIP is down. 4 SC edit delete
141 1Z0-048 The following are the steps that you have taken so far in a two-node RAC implementation: 141-qracm.png You run OUI from any node and the software would be installed on both the nodes successfully. You run OUI from any node and the installer would prompt you to run the crs_start command to start the resources that are offline. You must run OUI from the first node ora....17a because running it from the second node ora....17b would result in an error. 1 SC edit delete
140 1Z0-048 You are running a two-instance database with six redo log groups defined and decide to add a third thread to support a third database instance on the third node of the cluster. Which three commands would you issue to achieve this using command line administration? (Choose three.) ALTER SYSTEM ENABLE THREAD 3; ALTER DATABASE ENABLE THREAD 3; ALTER SYSTEM ADD LOGFILE THREAD 3 GROUP 8; ALTER SYSTEM ADD LOGFILE THREAD 3 GROUP 7; ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 7; ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 8; 2, 5, 6 MC edit delete
139 1Z0-048 Which two statements about the correct configuration of the flash recovery area in a RAC environment are true? (Choose two.) Set the flash recovery area size to no smaller than 20 GB. Set the DB_RECOVERY_FILE_DEST initialization parameter to the same value on all instances. Set the DB_RECOVERY_FILE_DEST_SIZE initialization parameter to the same value on all instances. The use of a common flash recovery area is not recommended on clusters containing more than four nodes. 2, 3 MC edit delete
138 1Z0-048 Your four-node RAC cluster is no longer coping with workloads for one of its databases at peak periods and you decide to add another node to the cluster. The current configuration has two RAC databases, each with four instances with only the second database using ASM as a clustered database file system. ASM is installed in a separate home. Which five steps must you take to add all the software components and processes to the new node before you run DBCA to add database and ASM instances on the new cluster nodes. Do not be concerned with the correct sequence for the steps. (Choose five.) Run netca from the new node to add a listener to the new node. Run addNode.sh in the ASM home/oui/bin directory from one of the existing nodes. Run addNode.sh in the RDBMS home/oui/bin directory from one of the existing nodes. Run racgons add_config from one of the existing nodes to add the ONS metadata to the OCR. Run cluvfy stage -pre crsinst from one of the existing nodes to verify the cluster configuration. Run addnode.sh in the Clusterware home/oui/bin directory from one of the existing nodes to define the new node to all existing nodes. Run addnode.sh in the Clusterware home/oui/bin directory from each of the existing nodes once to define the new node to each existing node. 1, 2, 3, 4, 6 MC edit delete
137 1Z0-048 After a power failure, you noticed that one of your cluster database instances did not start automatically, whereas all other instances came up successfully. What would you do to determine the precise cause for the instance startup failure? (Choose three.) Check the resource state by using the CRS_STAT command. Check for OCR corruptions by using the OCRCHECK command. Check the alert.log file that belongs to the instance that did not start. Check the alert.log file that belongs to the Oracle Clusterware software. Check if the Oracle Clusterware is functional by using the CRSCTL command. Reboot the node where the failing instance resides to check if the problem is persistent. Enable extra debugging in the Oracle Clusterware software by using the CRSCTL command. 1, 3, 4 MC edit delete
136 1Z0-048 Read the following statements about the ASM and OCFS file systems: 136-qracm.png Group A: 2, 3, 4 Group B: 1, 5, 6 Group A: 1, 3, 4 Group B: 3, 4, 5 Group A: 5, 6 Group B: 1, 2, 3, 4 Group A: 3, 4 Group B: 1, 2, 5, 6 3 SC edit delete
135 1Z0-048 Your company is about to switch from one Internet Service Provider (ISP) to another, and this change of ISP comes along with a whole new set of network addresses. Your job is to change the VIP addresses of your company's Oracle cluster. How would you apply this change? Reinstall the Oracle Clusterware layer of your cluster. Change the VIP addresses in DNS and the cluster would pick up the new addresses automatically. Change the VIP addresses on the cluster using SRVCTL while the cluster is fully functional. Stop all VIP-dependent components on all cluster nodes, make the necessary changes in DNS, and then restart all VIP-dependent components. Stop all VIP-dependent cluster components on one node, make the necessary changes in DNS, change the VIP using SRVCTL, restart all VIP-dependent components, and then perform these steps on all the remaining nodes one at a time. 5 SC edit delete
134 1Z0-048 While creating a new service inside your ORCL database, you encounter a problem during the execution of the srvctl add service command. 134-qracm.png Set the DEBUG environment variable to TRUE before you execute the srvctl command. Set the SRVM_TRACE environment variable to TRUE before you execute the srvctl command. Set the SRVM_DEBUG environment variable to TRUE before you execute the srvctl command. Request extra information by adding the -d (debug) command-line flag at the srvctl command line. Request extra information by adding the -v (verbose) command-line flag at the srvctl command line. 2 SC edit delete
133 1Z0-048 You are the administrator of a Linux-based Oracle cluster. To meet your company's disaster recovery requirements, you have to make backups of the OCR to a tape device. What are your options? (Choose all that apply.) Use RMAN to back up the OCR from disk to tape. Use the Linux DD command to write the OCR directly to tape. Use your favorite tape backup command to back up the OCR from disk to tape. Use the OCRCONFIG command to have CRSD write the OCR backup to tape for you. Use your favorite tape backup command to back up the physical OCR backups from disk to tape. 5 SC edit delete
132 1Z0-048 Which three statements regarding backup of the voting disk are true? (Choose three.) On UNIX platforms, the voting disk can be backed up with the dd command. A backup of the voting disk should be taken whenever an RMAN catalog reset is done. A backup of the voting disk should be taken whenever a new node is added to the cluster. A backup of the voting disk should be taken whenever an existing node is removed from the cluster. Whenever a voting disk backup is made, the Clusterware software should be stopped on all nodes in the cluster. 1, 3, 4 MC edit delete
131 1Z0-048 Which two statements regarding Oracle Clusterware are correct? (Choose two.) The Oracle Database 10g version of the srvConfig.loc file is the ocr.loc file. The Oracle9i srvConfig.loc file still exists for backward compatibility in Oracle Database 10g. The Oracle Database 10g CRS stack is compatible with Oracle 9i Group Services (GSD) processes. The installation of Oracle Clusterware is not necessary if you have already installed vendor-specific clusterware. 1, 2 MC edit delete
130 1Z0-048 Your system administrator informs you that there are a number of unexpected system reboots occurring on one of your Oracle database clusters. The system administrator has no clue whether this is a hardware or system software issue or whether the Oracle Clusterware is causing these reboots. To determine the source of these unexpected reboots, the system administrator asks you how you can enable debugging on the Oracle Clusterware software components. Which two statements are true regarding Oracle Clusterware debugging? (Choose two.) You can enable Oracle Clusterware debugging dynamically. You enable Oracle Clusterware debugging using the SRVCTL command. You have to restart Oracle Clusterware after enabling debugging to activate it. You enable Oracle Clusterware debugging using the CRSCTL command as the root user. You enable Oracle Clusterware debugging using the CRSCTL command as the oracle user. 1, 4 MC edit delete
129 1Z0-048 James works as a senior DBA for a finance company. He plans to implement a test RAC environment. 129-qracm.png Option 1 Option 2 Option 3 Option 4 either Option 2 or Option 4 either Option 1 or Option 2 3 SC edit delete
128 1Z0-048 Because of the increasing load on your Oracle Database 10g Release 2 cluster, your company has decided to add one extra node to your existing four-node cluster. To prevent errors during this process, you want to make use of the Cluster Verification Utility (CLUVFY) so that you can check if you meet all requirements before you execute each step in this node-adding process. From where can you run CLUVFY? only from the Oracle Clusterware ORACLE_HOME only from the Oracle Clusterware distribution media only from a non-Oracle Clusterware ORACLE_HOME only after downloading it from the Oracle Technology Network (OTN) Web site from both the Oracle Clusterware distribution media and the Oracle Clusterware ORACLE_HOME from the Oracle Clusterware distribution media, any available RAC and/or CRS ORACLE_HOME on your cluster, and from the location where you downloaded it from in the Oracle Technology Network (OTN) Web site from the Oracle Clusterware distribution media, any ORACLE_HOME on the node from which you installed the first four nodes, and from the location where you downloaded it from in the Oracle Technology Network (OTN) Web site 6 SC edit delete
127 1Z0-048 Several steps must be followed to successfully add a node to your cluster database. Assuming that a UNIX platform is used, which of the steps listed below is not correct? (Choose the incorrect step.) Add instances via DBCA. Configure the OS and hardware for the new node. Reconfigure listeners for the new node with netca. Add the node to the cluster using the addnode.sh script run from ORA_CRS_HOME. Add the RAC software to the new node using orainstRoot.sh from ORACLE_HOME. 5 SC edit delete
126 1Z0-048 View the Exhibit. You are asked to help a colleague to logically remove node NLEDUC2 from a RAC cluster installation. On observing the colleague's terminal, you notice the output as seen in the exhibit. Based on this, which five additional steps would you recommend? Do not be concerned with the correct sequence for the steps. (Choose five.) Remove the listener from NLEDUC2. Remove the node from the clusterware. Stop and restart the nodeapps on NLEDUC1. Stop and restart the clusterware on NLEDUC1. Check that the ONS configuration has been updated on the remaining node. Check that the database and ASM instances are all terminated on NLEDUC2. Check that the node has been removed from the database and ASM inventories. Check that the software has been removed from the database and ASM homes on NLEDUC2. 2, 5, 6, 7, 8 MC edit delete
125 1Z0-048 After migrating from a 10g R1 cluster to 10g R2, you decide to multiplex your voting disk. Which are the two ways in which you can accomplish this task? (Choose two.) You should not use symbolic links. You can add additional voting disks online. You must add additional voting disks offline. You may use the VIPCA utility to add new voting disks. You may use the command: crsctl add css votedisk 2, 5 MC edit delete
124 1Z0-048 View the Exhibit. 124-qracm.png The instance was started by CRS after the system was rebooted, but someone stopped it from within SQL*Plus. The database instance's autostart attribute indicates that CRS should not restart it after system boot. The instance was not started by CRS because its target state was set to "offline" before the system was rebooted. The instance was started by CRS but due to multiple instance failures CRS disabled the database instance, thereby preventing further restarts. The instance could not be started by CRS because this instance depends on an ASM instance, which has its autostart attribute set to a value, thereby preventing CRS from starting this ASM instance after a system reboot. 2 SC edit delete
123 1Z0-048 Your network administrator wants to know why you need extra IP addresses for your Oracle Real Applications Cluster now that you are upgrading from Oracle9i to Oracle 10g. Which four statements would you use to explain to your network administrator the reason for requiring extra IP addresses? (Choose four.) The VIPs should be registered in the DNS. The VIPs should not be registered in the DNS. A VIP would notify its client when a failure occurs. A VIP would always accept a connection from a client. The VIPs are used to circumvent network timeouts on the Cluster Interconnect. The VIP addresses must be on the same subnet as the public host network addresses. The VIPs are used to prevent connection request timeouts during client connection attempts. Database clients should connect to a RAC database using VIPs for the best High Availability solution. 1, 6, 7, 8 MC edit delete
122 1Z0-048 Which three statements regarding the management of Oracle Cluster Registry (OCR) on a UNIX platform are true? (Choose three.) The default target location of each automatically generated OCR backup file is the /cdata/ directory. You can customize the OCR backup frequencies and the number of retained copies. The OCR autobackups are automatically copied to every ORA_CRS_HOME on each node in the cluster. The location of the OCR autobackup can be changed to a shared file system with the ocrconfig -backuploc command. One CRS instance in the cluster automatically creates OCR backups every four hours, at the beginning of each day and of each week. 1, 4, 5 MC edit delete
121 1Z0-048 You are about to bring your Web server under control of the Oracle Clusterware to make it highly available. Which actions do you need to perform to accomplish this task? (Choose all that apply.) Write an action script that Oracle Clusterware would use to start, stop, and check the status of an application. Create an application profile using crs_profile, register it with crs_register, set its permission with crs_setperm, and then start it with crs_start. Create an application VIP profile using crs_profile, register it with crs_register, set its permission with crs_setperm, and then start it using crs_start. Have the system administrator create an application VIP at the operating system level for you to use with the application. Once done, manage the Web server with SRVCTL. 1, 2, 3 MC edit delete
120 1Z0-048 You have migrated your 10g R1 cluster to 10g R2. You wish to create multiple copies of the voting disk. What must you consider when doing this? If multiplexing, two voting disks on independent devices is ideal. If multiplexing, three voting disks on independent devices is ideal. Since ASM is the stated direction of Oracle, ASM is the best storage for voting disks. For the voting disk, it is better to rely on multipathing solutions instead of multiplexing. 2 SC edit delete
119 1Z0-048 You are considering issues involving backup and recovery of the voting disk. Select four correct statements. (Choose four.) Backup can be performed online. Use symbolic links to simplify recovery of the voting disk. To back up the voting disk, use the command ocrconfig -export. If you lose your voting disk and do not have a backup, you must reinstall Oracle Clusterware. You can determine the voting disks currently used by CSS with the command crsctl query css votedisk. 1, 2, 4, 5 MC edit delete
118 1Z0-048 To install Oracle Database 10g RAC on a UNIX platform, which four directories will you identify for use? (Choose four.) NET_ADMIN directory Oracle inventory directory group services directory (GSD_HOME) Oracle base directory (ORACLE_BASE) CRS home directory (ORA_CRS_HOME) Oracle home directory (ORACLE_HOME) 2, 4, 5, 6 MC edit delete
117 1Z0-048 What is true about Virtual Internet Protocol Configuration Assistant (VIPCA)? The VIPCA application must be run manually on all nodes in the cluster. Each Virtual IP (VIP) configured requires an unused and resolvable IP address. The VIP for each node should be bound to the adapter that is acting as the private interconnect. The ifconfig -a command is used to back out a faulty VIPCA configuration. 2 SC edit delete
116 1Z0-048 You are working with Oracle Support to investigate to what extent a disk subsystem corruption has affected your Oracle cluster configuration. The support engineer wants you to run the OCRCHECK command and read out the output. What is the effect of running the OCRCHECK command? It performs an OCR integrity check. It checks whether there is enough disk space for the OCR. It checks whether the Oracle Cluster Registry daemons are running normally. It checks whether the OCR daemons are making regular backups of the OCR. It checks whether all your cluster resources, such as databases, instances, listeners, and node applications, are registered within the OCR. 1 SC edit delete
115 1Z0-048 Which three statements are correct regarding ASM instances in a RAC environment? (Choose three.) ASM instances can mount different sets of disk groups. ASM instances recognize their disks by looking at their headers. ASM instances can use different values for ASM_POWER_LIMIT. ASM instances must all have the same value for ASM_DISKSTRING. ASM instances must all have the same value for ASM_DISKGROUPS. 1, 2, 3 MC edit delete
114 1Z0-048 Which two statements are true in a RAC environment? (Choose two.) After you create a service, you need to enable it for CRS to manage it. After you create a service using SRVCTL, you need to start it with a separate command. When using DBCA to create a service, you do not need to add the corresponding TNS entry in your tnsnames.ora on the cluster nodes. When using SRVCTL to create a service, you do not need to add the corresponding TNS entry in your tnsnames.ora. After you create a service using Database Configuration Assistant (DBCA), you need to start it with a separate command. 2, 3 MC edit delete
113 1Z0-048 Which initialization parameter would you use for each RAC instance to make sure that each listener on each RAC node is aware of the load of all the others? LOCAL_LISTENER REMOTE_LISTENER REMOTE_DEPENDENCIES_MODE PREFER_LEAST_LOADED_NODE_ 2 SC edit delete
112 1Z0-048 You are creating a database in your RAC implementation. You are using the DBCA to create the database, and you selected the Raw Devices Mapping file on one of the screens of the DBCA. What is the reason for selecting this file? You want the DBCA to bind the partitions to raw devices. You want to set the appropriate raw partition for each database file. You want to configure an ASM diskgroup containing raw devices. You want to provide the DBCA with a list of all the storage devices that are currently bound to a raw interface. 2 SC edit delete
111 1Z0-048 In which directory should you put your callout scripts on your RAC nodes? $ORACLE_HOME/opmn/conf/ $ORA_CRS_HOME/opmn/conf/ $ORACLE_HOME/racg/usrco/ $ORA_CRS_HOME/racg/usrco/ 4 SC edit delete
110 1Z0-048 What does your client connection do using this connect string? 110-qracm.png It connects you to the least loaded node. It connects you to the least loaded instance. It randomizes its connection request on the available listeners. It connects you to the instance on the least loaded node that currently accepts logins for the SALES.US.ACME.COM service. 3 SC edit delete
109 1Z0-048 After the cluster database has been successfully created, several postinstallation tasks should be completed. Identify three of them. (Choose three.) Create the ASM instance. Back up the root.sh script. Initialize the cluster backup procedure. Set up additional required user accounts. Verify the Enterprise Manager/Oracle Cluster Registry configuration by running srvctl config database -d db_name. 2, 4, 5 MC edit delete
108 1Z0-048 Which optional parameter of the DESCRIPTION clause of a TNS entry can you use to make sure that another protocol address is tried if the first one fails? FAILOVER LOAD_BALANCE SOURCE_ROUTE TYPE_OF_SERVICE 1 SC edit delete
107 1Z0-048 View the Exhibit, which displays a portion of an ADDM report from a RAC database. Which three statements are true? (Choose three.) The ADDM report output reveals a "hot block" condition. A LOCK TABLE statement is causing excessive inter-instance messaging. The SQL statement with the ID dqsu2hwys8rcf was executed 40000 times The Findings Path section indicates that the Cluster wait class is consuming a significant proportion of the database time. 2, 3, 4 MC edit delete
106 1Z0-048 Richard is a senior DBA and has prepared a plan for RAC implementation in his company. 106-qracm.png 2, 5, 7, 8 1, 3, 4, 6 3, 4, 6, 7, 8 2, 5, 6, 7, 8 1, 2, 4, 5, 6, 7 2 SC edit delete
105 1Z0-048 You are asked by the DBA team leader to consolidate three different Oracle databases, which supported three separate workloads, into one large three-instance RAC database on a three-node cluster. 105-qracm.png three entries in the address list for the HR service for the listeners on all three nodes three entries in the address list for the CRM service for the listeners on all three nodes three entries in the address list for the ORDERS service pointing to the listeners on all three nodes two entries for the address list for the HR service for the listeners on the nodes containing the preferred instances for HR one entry for the address list for the ORDERS service for the listeners on the nodes containing the preferred instance for ORDERS two entries for the address list for the CRM service pointing to the listeners on the nodes containing the preferred instances for CRM 1, 2, 3 MC edit delete
104 1Z0-048 Which three statements about patching Oracle products in a clustered environment are true? (Choose three.) OUI manages patches in a clustered environment only if a shared ORACLE_HOME is employed. OUI prevents potentially destructive concurrent patch installations through the use of Inventory List Locks. The Oracle Universal Installer (OUI) is cluster-aware and able to manage patches on all nodes in your cluster. The OUI automatically manages the patch installation progress, including the copying of files to remote nodes, just as it does with the CRS and database binary installations. 2, 3, 4 MC edit delete
103 1Z0-048 You have attended a user group presentation on RAC and based on what you have learned you feel that your company would benefit from having the RAC option to meet its Oracle database requirements in several ways. Your manager does not know much about RAC and asks you to create a presentation to the team explaining RAC, and whether it should be implemented in your installation. Which three statements explain the benefits and implications of RAC? (Choose three.) RAC alone would not help protect from human errors. RAC would increase availability in the event of data failures. RAC would increase availability in the event of a network failure. RAC alone would increase availability when doing release upgrades. RAC would increase scalability for all application workloads in all cases. RAC would increase availability in the event of node and instance failures. RAC used in conjunction with parallel execution may provide speedup of DSS queries. RAC used in conjunction with parallel execution may provide for speedup of OLTP workload processes. 1, 6, 7 MC edit delete
102 1Z0-048 You want check whether the group services node application is running on all the nodes in your cluster before you create a cluster database. Which utility can you use to make sure the node application is running on all nodes in the cluster? onsctl crsctl lsnrctl crs_stat addnode.sh 4 SC edit delete
101 1Z0-048 Which background process communicates load information to its listener? PMON SMON MMON LMON 1 SC edit delete
100 1Z0-048 Which two statements about parallel recovery in a RAC environment are true? (Choose two.) The RECOVERY_PARALLELISM initialization parameter specifies the number of redo application server processes participating in instance or media recovery. The use of the RECOVERY_PARALLELISM initialization parameter is the only way to initiate parallel recovery. The RECOVERY_PARALLELISM initialization parameter causes serial recovery if the value is greater than two. Parallel recovery is most effective at reducing recovery time while concurrently recovering several data files on several disks. 1, 4 MC edit delete
99 1Z0-048 Which CREATE SEQUENCE option is the most scalable? CACHE ORDER NOCACHE ORDER CACHE NOORDER NOCACHE NOORDER 3 SC edit delete
98 1Z0-048 What should you do when creating a disk group that would store your RAC database? Make sure that all database instances are functional. Make sure that the disk group is mounted by all ASM instances. Make sure that ASM targets are accessible from Database Control. Make sure that all database instances are running in restricted mode. 2 SC edit delete
97 1Z0-048 Your company requires that certain database systems be made continuously available because there are revenue-earning applications using Oracle databases. You already use RAC; it is a requirement for the applications to have continuous read and write access to all schema objects in the database during routine DBA maintenance activities. Which three technologies would you recommend for minimizing planned downtime for the application caused by unavailability of data due to those activities? (Choose three.) Bigfile Tablespaces Online Index Rebuild Online Table Redefinition Fast Start Fault Recovery Rolling Release Upgrades Hardware-Assisted Resilient Data 2, 3, 5 MC edit delete
96 1Z0-048 Which parameter file should you use to configure the Oracle notification server on your RAC nodes? $ORACLE_HOME/opmn/conf/ons.config $ORA_CRS_HOME/opmn/conf/ons.config $ORA_CRS_HOME/racg/usrco/ons.config $ORACLE_HOME/racg/usrco/ons.config 2 SC edit delete
95 1Z0-048 Which two views can be used to identify SQL statements affected by interconnect latencies in your RAC environment? (Choose two.) the V$SQL view the V$SQLTEXT view the V$SQLAREA view the V$SQL_PLAN view the V$SQL_CURSOR view 1, 3 MC edit delete
94 1Z0-048 For which two server metrics can you define thresholds for your services? (Choose two.) CPU_TIME_PER_CALL ELAPSED_TIME_PER_CALL LOGICAL_READ_PER_CALL APPLICATION_WAIT_TIME PHYSICAL_READ_PER_CALL SQL_EXECUTE_ELAPSED_TIME 1, 2 MC edit delete
93 1Z0-048 Which two statements regarding the installation of the Oracle 10g Database software are true? (Choose two.) The Oracle Universal Installer (OUI) can detect the cluster hardware and allow the user to install the software on the local node or choose all nodes to install the software. The OUI does not support a RAC installation if the Standard Edition is chosen from the Installation Type page. If the OUI does not display all of the available nodes in your cluster, check the viability of your cluster and its associated nodes by executing the chkcluster command from $ORA_CRS_HOME/bin directory. The directory path for the Oracle 10g Database software must not be the same as the Oracle 10g Clusterware home directory. 1, 4 MC edit delete
92 1Z0-048 You decide to implement a Dataguard configuration for your RAC installation to support your disaster recovery architecture. There are two instances on the primary and two on the physical standby. Which are the two appropriate settings for the DG_BROKER_CONFIG_FILE1 and DG_BROKER_CONFIG_FILE2 initialization parameters? (Choose two.) DG_BROKER_CONFIG_FILE1 set to a nonshared location for each secondary database instance and DG_BROKER_CONFIG_FILE2 set to a shared location for each secondary database instance on the secondary database cluster. DG_BROKER_CONFIG_FILE1 set to a location shared between each standby database instance and DG_BROKER_CONFIG_FILE2 set to a different location shared between each standby database instance on the standby database cluster. DG_BROKER_CONFIG_FILE1 set to the same shared location shared between the first instance of both the primary and the standby databases. DG_BROKER_CONFIG_FILE1 set to a nonshared location for each primary database instance and DG_BROKER_CONFIG_FILE2 set to a shared location for each primary database instance on the primary database cluster. DG_BROKER_CONFIG_FILE1 set to a location shared between each primary database instance and DG_BROKER_CONFIG_FILE2 set to a different location shared between each primary database instance on the primary database cluster. DG_BROKER_CONFIG_FILE2 set to the same shared location for the second instance of both the primary and the standby databases. 2, 5 MC edit delete
91 1Z0-048 Which statement is true regarding undo management in a RAC environment? It is possible to store undo tablespaces on nonshared disks. A RAC database contains one undo tablespace shared by all instances. A RAC database must have defined only one undo tablespace for each instance. You cannot mix automatic undo management and manual undo management. 4 SC edit delete
90 1Z0-048 Over a six-month period, you have been regularly monitoring your four-instance RAC database, which is running on the first 4 nodes of a 6-node cluster, by using ADDM and by monitoring well-known combinations of wait event and statistics in AWR reports. 90-qracm.png Tune SQL from the BATCH service programs because they may benefit from SQL tuning. The BATCH service programs may scale well and could benefit from adding new database instances on either node 5 or 6, or on both. Tune SQL for the OLTP and DSS service programs because they may benefit from SQL tuning. The OLTP and DSS service programs may scale well and could benefit from adding new database instances on either node 5 or 6, or on both. The OLTP and DSS service programs may scale well and could benefit from adding new database instances on one or both of nodes 5 and 6, and by adding more nodes the SQL for BATCH service programs would perform better due to more CPU power. 1, 4 MC edit delete
89 1Z0-048 Which three statements about quiescing a RAC database are true? (Choose three.) It is possible to take a cold backup while the database is in a quiesced state. Use the ALTER SYSTEM QUIESCE RESTRICTED statement from a single instance. The database cannot be opened from another instance until the ALTER SYSTEM QUIESCE?statement finishes execution. The ALTER SYSTEM QUIESCE RESTRICTED and ALTER SYSTEM UNQUIESCE statements affect all instances in a RAC environment. 2, 3, 4 MC edit delete
88 1Z0-048 View the Exhibit and examine the diagram of the RAC environment implemented on a Linux platform in your company. 88-qracm.png by using DBCA on all nodes by using the ASMCMD command-line utility on both the nodes by using Oracle Universal Installer (OUI) on any one of the nodes by using the oracleasm configure command on both the nodes by using the oracleasm configure command on any of the nodes by using Database Configuration Assistant (DBCA) on any one of the nodes 3, 6 MC edit delete
87 1Z0-048 You need to add a new service to your RAC database, 87-qracm.png The services must be started using the SRVCTL START SERVICE command. The service must be started using the DBMS_SERVICE.START_SERVICE procedure. The service must have at least one preferred or available instance that is running and accepting logins. All the listeners must be reloaded using LSNRCTL RELOAD to recognize the dynamically created service. The TNSNAMES.ORA file or a name server must contain the net service entries for the DBA service. The ALTER SYSTEM REGISTER command must be used to induce PMON to register the service with the listeners. 3, 5 MC edit delete
86 1Z0-048 Your company has certain standard practices for technology and you are configuring ASM disk groups for your four-node RAC cluster. The company guidelines suggest that there is one disk group for the flash recovery area that is shared by all databases and a separate disk group for the database area of all databases. Which three exceptions exist that may require you to create additional disk groups? (Choose three.) The retention policy for backups are different for different databases. There are large nonpartitioned tables accessed frequently using indexes. The disk farm has different disk models with different characteristics and ages. Some databases operate in ARCHIVELOGMODE and others in NOARCHIVELOGMODE. Some database instances are shut down every night while others are always running. Applications using the databases have different Service-Level Agreements for response time and throughput. There are partitioned tables where the older partitions are in read-only tablespaces and seldom accessed, but the more recent partitions are frequently accessed. 3, 6, 7 MC edit delete
85 1Z0-048 Which two statements are true regarding high availability in a RAC environment? (Choose two.) When you have a serious crash of your primary site, Data Guard Broker automatically initiates the failover to the standby site. It is the Data Guard Broker's responsibility to communicate with CRS during a switchover operation to stop and start services according to each Data Guard site role. You can have multiple RAC instances apply standby redo log files to the standby database. Each primary RAC instance must send its redo stream to the same standby RAC instance. When you have a serious crash of your primary site, it is your responsibility to initiate the failover to the standby site in case you are not using the Fast-Start Failover feature. 2, 5 MC edit delete
84 1Z0-048 You define the ERP service using this statement: 84-qracm.png two on RAC01 two on RAC02 only one on RAC01 one on RAC01 and one on RAC02 3 SC edit delete
83 1Z0-048 You decide to change the redo thread of one of your database instances. 83-qracm.png 6, 3, 2, 5, 1, 4 6, 3, 5, 2, 1, 4 3, 6, 5, 2, 1, 4 2, 6, 3, 5, 1, 4 2, 5, 1, 4, 6, 3 2, 5, 1, 4, 3, 6 1, 2, 3 MC edit delete
82 1Z0-048 To complete a cluster database creation, the DBA must choose the cluster database storage method. Which storage choice is not correct? (Choose the incorrect one.) Raw Devices Cluster File System Standard UNIX file system Supported SAN/NAS storage Automatic Storage Management (ASM) 3 SC edit delete
81 1Z0-048 View the Exhibit and examine an installation step of Oracle Enterprise Manager Grid Control 10gR2 to manage your RAC installation. 81-qracm.png 5561 1521 3938 1158 4889 2 SC edit delete
80 1Z0-048 You are implementing a three-node RAC setup in your company. 80-qracm.png to check for node connectivity and Clusterware integrity to check whether the dbinst directory is available on all the nodes to check if the ORACLE_HOME environmental variable is set to a correct value or not before the database installation to check for the existence of Oracle database software installation files in the /stage directory on all the nodes 1 SC edit delete
79 1Z0-048 Which statement is true? You must use RMAN to migrate your data files to ASM storage. You must use RMAN to migrate your tempfiles to ASM storage. You must use RMAN to migrate your flashback log files to ASM storage. You must use RMAN to migrate your online redo log files to ASM storage. You must use RMAN to migrate your change-tracking file to ASM storage. You can migrate your entire database to ASM storage without shutting down your database. 1 SC edit delete
78 1Z0-048 Which two tools will prompt you for the possible creation of ASM instances in a RAC environment? (Choose two.) OUI DBCA VIPCA SRVCTL ASMCMD 1, 2 MC edit delete
77 1Z0-048 You have a four-node cluster with instances RDBD1, RDBD2, RDBD3, and RDBD4. 77-qracm.png Encourage shorter transactions. Set _lm_msg_batch_size to a higher value. Set fast_start_mttr_target to a higher value. Re-create the index as a global hash partitioned index. Increase the sequence cache size if retaining the sequence. Re-create the table using a natural key instead of a surrogate key. 4, 5, 6 MC edit delete
76 1Z0-048 You are migrating a single-instance Oracle database to RAC. 76-qracm.png Local File System with each instance writing to a local location provided that the path names are identical on all nodes. ASM diskgroup +DB_DG as specified for the Database Area provided that the ASM diskgroup is mounted on all ASM instances. ASM diskgroup +FR_DG as specified for the Flash Recovery Area provided that the ASM diskgroup is mounted on all ASM instances. Cluster File System with each instance writing to a separate location as long as they are in directories under the same mount point. Local File System with each instance writing to a local location provided that NFS read mount points are created to all other nodes with instances of the database. Cluster File System with each instance writing to a shared location. 3, 5, 6 MC edit delete
75 1Z0-048 View the Exhibit. 75-qracm.png The instance was started by CRS after the system was rebooted, but someone stopped it from within SQL*Plus. The database instance autostart attribute is set to a value, thus preventing CRS from starting it after a system reboot. The instance was not started by CRS because its target state was set to "offline" a while before the system was rebooted. The instance was started by CRS but due to multiple instance failures CRS disabled the database instance, thereby preventing further restarts. The database instance could not be started by CRS because this instance depends on an ASM instance, whose autostart attribute indicates that CRS should not start this ASM instance after system boot. 5 SC edit delete
74 1Z0-048 The infrastructure team at your company requires your advice on maximizing availability using Maximum Availability Architecture and any other features that will help reduce planned downtime both for database instances and for the availability of database objects which applications depend on. You are already running a four node RAC cluster to protect against instance and node failures. Which four would you recommend if they are not already implemented? (Choose four.) use of ASM use of online index rebuild use of the DBMS_REDEFINITION package a physical standby database for rolling upgrades use of freelists to manage space in table and index segments use of segment shrinking to reorganize space in tables and indexes 1, 2, 3, 6 MC edit delete
73 1Z0-048 You are implementing a three-node RAC setup in your company. You have already performed these tasks: 73-qracm.png to check for node connectivity and Clusterware integrity to check whether the dbinst directory is available on all the nodes to check if the ORACLE_HOME environmental variable is set to a correct value or not before the database installation to check for the existence of Oracle database software installation files in the /stage directory on all the nodes 1 SC edit delete
72 1Z0-048 According to the Maximum Availability Architecture, which case is best? Run two identical sites with a primary RAC database on the first site, and only a RAC logical standby database on the second site. Run two identical sites with a primary RAC database on the first site, and only a RAC physical standby database on the second site. Run two identical sites with a primary RAC database on the first site, and RAC physical and logical standby databases on the second site. Run two identical sites with a primary RAC database on the first site, and non-RAC physical and logical standby databases on the second site. 3 SC edit delete
71 1Z0-048 What does server-side Connect-Time Load Balancing do to complement the client-side Connect-Time Load Balancing function of balancing the connection requests to all the listeners in the address list on the client side? It balances the load for each service across all available instances for that service, according to servicespecific load-balancing requirements. It balances the load for each service across all instances for that service, according to the service-specific load-balancing requirements. It balances the load for each service across all preferred instances for all services, according to the servicespecific load-balancing requirements. It balances the load for each service across all preferred instances for that service, according to the servicespecific load-balancing requirements. It balances the load for each service across all preferred instances for that service, according to the global load-balancing requirements. 4 SC edit delete
70 1Z0-048 In which directory should you put your callout scripts on your RAC nodes? $ORACLE_HOME/opmn/conf/ $ORA_CRS_HOME/opmn/conf/ $ORACLE_HOME/racg/usrco/ $ORA_CRS_HOME/racg/usrco/ 4 SC edit delete
69 1Z0-048 View the Exhibit. 69-qracm.png If the redo receive load is spread across multiple receiving instances then the primary redo transport is less likely to become a bottleneck. Multiple standby instances allow the redo to be applied more quickly by the standby apply instance after the redo has already arrived from the primary. The workloads of the archive processes on the standby instances would be balanced, thereby allowing load balancing across the cluster where the standby resides. The services on the primary would be symmetric allowing performance on each instance to be equal in the event of a switchover or failover to the standby database. Multiple standby instances allow the redo to be written to standby redo logs more quickly than just using a single receiving instance by reducing commit time on the primary instances. 1, 5 MC edit delete
68 1Z0-048 Which three statements about deleting instances from a RAC database on a UNIX platform are true? (Choose three.) During a delete operation, the DBCA removes the instance and the instance Oracle Net configuration. The DBCA can be used to delete an instance from a RAC database. To delete an instance, start the DBCA on the node that hosts the instance that you want to delete. To delete an instance, start the DBCA on a node other than the node that hosts the instance that you want to delete. 1,2,4 MC edit delete
67 1Z0-048 Read the following statements about a file system: 67-qracm.png ext2 NFS ASM NTFS OCFS2 5 SC edit delete
66 1Z0-048 When an ASM instance initializes, ASM discovers and examines the contents of all the disks that are in the paths designated in the ASM_DISKSTRING initialization parameter. Under which four other circumstances does disk discovery take place? (Choose four.) when you query V$ASM_DISK when you query V$ASM_DISKGROUP when you query V$ASM_OPERATION when you run ALTER DISKGROUP...ADD DISK when you run ALTERDISKGROUP...RESIZEDISK 1,2,4,5 MC edit delete
65 1Z0-048 After adding two new high-performance nodes to your existing eight-node Oracle Database cluster, you decide to remove the two oldest nodes from your cluster. You start by removing the instances from the nodes you are about to remove by using the Database Configuration Assistant (DBCA). During the execution, a problem arises and the DBCA terminates with a fatal exception. Before you contact Oracle Support, you want to create a Java-based tool trace file so that Oracle Support can assist you in resolving this issue as quickly as possible. How would you create this trace file? Set the DEBUG environment variable to TRUE before you execute the DBCA command Set the SRVM_TRACE environment variable to TRUE before you execute the DBCA command. Set the SRVM_DEBUG environment variable to TRUE before you execute the DBCA command. Request extra information by adding the -d (debug) command line flag at the DBCA command line There is no need to do any thing special because Java-based tool tracing is enabling by default for DBCA Request extra information by adding the-v(verbose) command-line flag at the DBCA command line 5 SC edit delete
64 1Z0-048 Which two statements regarding Oracle Clusterware are correct? (Choose two.) The Oracle Database 10g version of the srvConfig.loc file is the ocr.loc file. The Oracle 9i srvConfig.loc file still exists for backward compatibility in Oracle Database 10g The Oracle Database 10g CRS stack is compatible with Oracle 9i Group Services (GSD) processes. The installation of Oracle Clusterware is not necessary if you have already installed vendor-specific clusterware. 1,2 MC edit delete
63 1Z0-048 The following are some of the tasks that are performed during a RAC implementation 63-qracm.png 1,3,4,6 2,3,4,6,7 2,3,5,7,8 All the tasks 1,2,3,5,6,8 3 SC edit delete
62 1Z0-048 View the Exhibit.You are asked to help a colleague to logically remove node NLEDUC2 from a RAC cluster installation. 62-qracm.png Remove the listener from NLEDUC2. Remove the node from the clusterware. Stop and restart the nodeapps on NLEDUC1 Stop and restart the clusterware on NLEDUC1 Check that the ONS configuration has been updated on the remaining node. Check that the database and ASM instances are all terminated on NLEDUC2. Check that the node has been removed from the database and ASM inventories Check that the software has been removed from the database and ASM homes on NLEDUC2. 2,5,6,7,8 MC edit delete
61 1Z0-048 You need to add a new service to your RAC database, called DBA, to account for all the work done by database administrator sessions performing routine maintenance, to make this visible in the v$service_stats view. The maintenance would be done at quieter times but restricted session is not an option due to round-the- clock access requirements. The database administration team may connect locally or remotely to the RAC database. You decide to use DBCA to create the new service. What must be true to allow client-server connection to the DBA service? (Choose two.) The services must be started using the SRVCTL START SERVICE command. The service must be started using the DBMS_SERVICE.START_SERVICE procedure. The service must have at least one preferred or available instance that is running and accepting logins. All the listeners must be reloaded using LSNRCTL RELOAD to recognize the dynamically created service. The TNSNAMES.ORA file or a name server must contain the net service entries for the DBA service. The ALTER SYSTEM REGISTER command must be used to induce PMON to register the service with the listeners. 3,5 MC edit delete
60 1Z0-048 The maximum number of redo threads for a database from 10g R2 is _____. determined by the maxlog files setting determined by the maxthreads setting determined by the maxinstances setting determined by the number of nodes in the cluster not limited because the control file can extend for more thread records if required to 3 SC edit delete
59 1Z0-048 You have a four-node cluster with instances RDBD1, RDBD2, RDBD3, and RDBD4. While evaluating statspack reports, you find nq: TX - index contention on page one under the category op 5 Timed Events. Further study finds an unusually high number of c buffer busy waits in the Wait Events section. Checking the Instance Activity Stats section, you see an unusually high value for eaf Node Splits. Using v$segment_statistics, you identify that the top segment with c buffer busy waits is the index prooducts_pk, which obtains the primary key from a sequence. You wish to present alternative solutions to the team to help reduce contention. Which three actions would you recommend to reduce the overheads? (Choose three.) Encourage shorter transactions Set_lm_msg_batch_size to a higher value. Set fast_start_mttr_target to a higher value. Re-create the index as a global hash partitioned index Increase the sequence cache size if retaining the sequence. Re-create the table using a natural key instead of a surrogate key. 4,5,6 MC edit delete
58 1Z0-048 On a UNIX platform, which three processes are required to be running on all nodes before initiating a cluster database creation? (Choose three.) crsd.bin evmd.bin ocssd.bin racgmon.bin 1,2,3 MC edit delete
57 1Z0-048 For which two server metrics can you define thresholds for your services? (Choose two.) CPU_TIME_PER_CALL ELAPSED_TIME_PER_CALL LOGICAL_READ_PER_CALL APPLICATION_WAIT_TIME PHYSICAL_READ_PER_CALL SQL_EXECUTE_ELAPSED_TIME 1,2 MC edit delete
56 1Z0-048 Your storage administrator informs you about some disk corruption issues in the disk subsystem where your Oracle Cluster Registry (OCR) is located. Your storage administrator has resolved these corruption issues by applying a patch to the storage subsystem, but to be sure that the OCR is not affected by this problem the administrator wants you to check the integrity of the OCR. How would you do this? There is no easy way to check your OCR for corruptions You can check whether the OCR is not corrupted by using the OCRCHECK command You create a logical export from the OCR by using the OCRCONFIG command and analyze the export file for errors. You create a physical backup of the OCR by using the OCRCONFIG command, and if this succeeds without errors you know that the OCR is not corrupted. You dump the OCR contents into a text file by using the OCRDUMP command, and if that succeeds with out errors you know that your OCR is not corrupted. 2 SC edit delete
55 1Z0-048 Which three statements are true regarding RAC instance startup and shutdown using SQL*Plus? (Choose three.) You can start multiple instances from a single SQL*Plus session on one node using Oracle Net Services connection strings. UsingSQL*Plus to startands top the RAC database instances is the preferred method because SQL*Plus is a Clusterware client. To start or shut down your local instance, initiate a SQL*Plus session connected as SYSDBA or SYSOPER, and then issue the required command. It is not possible to start up or shut down more than one instance at a time in SQL*Plus, so you cannot start or stop all the instances for a cluster database with a single SQL*Plus command. 1,3,4 MC edit delete
54 1Z0-048 After a failed cluster database creation process, you realize that the contents of the OCR does not match the current cluster configuration anymore. Before you started the database creation process, you created a logical backup of the OCR, and now you want to use this logical backup to bring the OCR contents in sync with the current cluster configuration. 54-qracm.png 5,3,8 6,4,9 5,4,8 6,3,9 7,6,3,9 7,6,4,9 7,6,3,2,9 2 SC edit delete
53 1Z0-048 You are requested to make your Web server, which accesses a clustered Oracle database, highly available. Which solution would you propose? Because you cannot use Oracle Cluster ware to protect your Webserver, you come up with an operating system solution. Bring your Webserver under control of the Oracle Cluster ware and use the public IP address to reach your Web server from your clients. Bring your Web server under control of the Oracle Clusterware and use the RAC VIP address to reach your Web server from your clients. Bring your Web server under control of the Oracle Clusterware and use the private IP address to reach your Web server from your clients. Bring your Web server under control of the Oracle Cluster ware and use an application VIP address to reach your Web server from your clients. 5 SC edit delete
52 1Z0-048 You are preparing to create a RAC cluster. You review the RAC requirements for UNDO tablespaces. Which three are valid statements? (Choose three.) You cannot assign a specific UNDO tablespace to a specific instance. It is not necessary to assign a specific UNDO tablespace to a specific instance. ALTER SYSTEM SET UNDO_TABLESPACE=undotbs3 SID='RDBD01'; is correct. ALTER DATABASE SET UNDO_TABLEPACE=undotbs3 SID='RDBD01'; is correct. If no UNDO tablespace is available when the instance starts, the instance stores undo records in the SYSTEM rollback segments. 2,3,5 MC edit delete
51 1Z0-048 Which three types of events can you trap using server-side callouts? (Choose three.) Listener down EM Agent down DB Console down Oracle instance up Service member down Service cardinality low Shadow application service up 4,5,7 MC edit delete
50 1Z0-048 To install Oracle Database 10g RAC on a UNIX platform, which four directories will you identify for use? (Choose four.) NET_ADMIN directory Oracle inventory directory group services directory (GSD_HOME) Oracle base directory (ORACLE_BASE) CRS home directory (ORA_CRS_HOME) Oracle home directory (ORACLE_HOME) 2,4,5,6 MC edit delete
49 1Z0-048 View the Exhibit and examine a database software installation step in a RAC environment. Which statement about the path is true? 49-qracm.png You must specify the location of the OCR file. You must specify the location of Oracle inventory. You must specify the same path that you specified to install ASM. You must specify the same path where Oracle clusterware is installed. You should specify a path under ORACLE_BASE where Oracle product is to be installed. You should specify the same path that you specified for the ORACLE_BASE environment variable. 5 SC edit delete
48 1Z0-048 View the Exhibit, which displays a portion of an ADDM report from a RAC database. Which three statements are true? (Choose three.) 48-qracm.png The ADDM report out put reveals a "hot block" condition. A LOCK TABLE statement is causing excessive inter-instance messaging. The SQL statement with the ID dqsu2hwys8rcf was executed 40000 times The Findings Path section indicates that the Cluster wait class is consuming a significant proportion of the database time. 2,3,4 MC edit delete
47 1Z0-048 Your company requires that certain database systems be made continuously available because there are revenue-earning applications using Oracle databases. You already use RAC; it is a requirement for the applications to have continuous read and write access to all schema objects in the database during routine DBA maintenance activities. Which three technologies would you recommend for minimizing planned downtime for the application caused by unavailability of data due to those activities? (Choose three.) Bigfile Tablespaces Online Index Rebuild Online Table Redefinition Fast Start Fault Recovery Rolling Release Upgrades Hardware-Assisted Resilient Data 2,3,5 MC edit delete
46 1Z0-048 In which two orders could you run the following commands to migrate your database to ASM? (Choose two.) 1 SHUTDOWN IMMEDIATE; 46-qracm.png 6,10,1,3,9,12,7,2,11,4,8,5 1,2,10,3,5,4,11,6,7,8,9,12 10,6,1,3,9,12,7,2,11,4,8,5 6,10,1,9,3,12,7,2,11,4,5,8 6,10,1,3,9,12,7,2,11,8,4,5 1,3 MC edit delete
45 1Z0-048 Which CREATE SEQUENCE option is the most scalable? CACHE ORDER NOCACHE ORDER CACHE NOORDER NOCACHE NOORDER 3 SC edit delete
44 1Z0-048 You observe a high number of gc current failure on your RAC system. What could be causing this issue? Too much manual locking is occurring. Too much parsing is occurring on your system. You are not using the correct private interconnect. There is too much contention on the High Water Mark enqueue of your tables. 3 SC edit delete
43 1Z0-048 You define the ERP service using this statement: You successfully establish a connection to your RAC database using the above connect string. How many connections are established, and on which instances? 43-qracm.png two on RAC01 two on RAC02 only one on RAC01 one on RAC01 and one on RAC0 4 SC edit delete
42 1Z0-048 Which two views can be used to identify SQL statements affected by interconnect latencies in your RAC environment? (Choose two.) the V$SQL view the V$SQLTEXT view the V$SQLAREA view the V$SQL_PLAN view the V$SQL_CURSOR view 1,3 MC edit delete
41 1Z0-048 You are asked to justify your proposed Maximum Availability Architecture to the IT director who feels that a four-node RAC cluster on the primary should not require a four-node RAC cluster for a physical standby database. The director suggests that either a non-RAC database should be used on the standby or that at most a two-node cluster is all that is required. Your proposed architecture was designed for both planned and unplanned downtime and for performance and scalability of services for all eventualities. How would you justify your proposal? (Choose two.) A non-RAC physical stand by would not provide for high availability in the case of a lights out fail over to the standby. A symmetric configurations prevent the standby from issuing a FLASHBACK DATABASE command if required after a failover. The four-node physical standby database provides for continuous availability of services but the two-node RAC physical standby database does not. The four-node physical standby provides for the same service preferences and performance profile in case of a failover to the physical standby database. A two-node physical standby would not allow as many services to be supported as a four-nodephysical standby does in case of a failover to the physical standby 1,4 MC edit delete
40 1Z0-048 You defined the HR service using the following command: srvctl add service -d RACDB -s HR -r RAC02,RAC03 -a RAC01 After a while, you realize that there is a workload peak on the HR service, and you decide to temporarily start HR on the RAC04 instance. Which command or series of commands would you use to start HR on RAC04? srvctl start service- d RACDB -s HR -i RAC04 srvctl remove service -d RACDB -s HR srvctl add service -d RACDB -s Hr -r RAC02,RAC03,RAC04 -a RAC01 srvctl remove service -d RACDB -s HR srvctl add service -d RACDB -s Hr -r RAC02,RAC03,RAC04 -a RAC01 srvctl start service -d RACDB -s HR srvctl modify service -d RACDB -s HR -i RAC02,RAC03,RAC04 -a RAC01 srvctl modify service -d RACDB -s HR -i RAC02, RAC03,RAC04 -a RAC01 srvctlstopservice -d RACDB -s HR srvctl start service -d RACDB -s HR 5 SC edit delete
39 1Z0-048 You want check whether the group services node application is running on all the nodes in your cluster before you create a cluster database. Which utility can you use to make sure the node application is running on all nodes in the cluster? onsctl crsctl lsnrctl crs_stat addnode.sh 4 SC edit delete
38 1Z0-048 The following query shows four MEMBER disks and three CANDIDATE disks. 38-qracm.png ALTER DISKGROUP dgroup1 ADD DISK '/dev/rdsk/disk*5','/dev/rdsk/disk*6'; ALTER DISKGROUP dgroup1 ADD DISK '/dev/rdsk/diska5','/dev/rdsk/diska6'; ALTER DISKGROUP dgroup1 ADD DISK '/dev/rdsk/diska5' name disk05,'/dev/rdsk/diska6' name disk06; ALTER DISKGROUP dgroup1 ADD DISK '/dev/rdsk/diska*'; ALTER DISKGROUP dgroup1 ADD DISK '/dev/rdsk/diska[56]'; 4 SC edit delete
37 1Z0-048 After a disk failure caused by a power outage, your CRS is unable to start up completely because all your OCR files are lost. Which commands would you use and in which order to redress this situation? 37-qracm.png 5,3,8 6,4,9 5,4,8 6,3,9 7,6,3,9 7,6,4,9 7,6,3,2,9 5 SC edit delete
36 1Z0-048 You and your colleague are working with Oracle Support on a database instance stability issue. The Oracle Support engineer wants you to issue a crsctl debug log crs ? crsctl debug log crs command to assist you in your troubleshooting assignment. Why does the Oracle Support engineer want you to do this? to list what debugging options are available on the CRS daemon to enable extra debugging on the currently running CRS daemon to list which debugging options are enabled on the CRS daemon to enable extra debugging on the CRS daemon the next time the CRS daemon is started to enable extra debugging on the currently running and CRS daemons as well as those that will run in the future 5 SC edit delete
35 1Z0-048 View the Exhibit. You are required to support your Oracle RAC configuration using ASM and RAID technology. You plan to discuss the storage configuration with the storage technology team. They have proposed a configuration as shown in the exhibit with a separate set of LUNs for the data disk group and the flash recovery area disk group and a 500 KB stripe size in line with other non-Oracle LUNs. The Data disk group has four 250G LUNs and the FRA disk group has four 500G LUNS, both of which are mirrored. What are three disadvantages of this configuration? (Choose three.) 35-qracm.png Index Range Scans would cause I/O to many different physical disks. The LUNs are not aligned with ASM Allocation Units, which may lead to I/O bottlenecks. Retention policies that require backups to be kept for long time periods may cause wasted space due to large allocation units. I/O to the flash recovery area disk group for backups may cause performance issues when full table scans are occurring during batch workloads. 2,3,4 MC edit delete
34 1Z0-048 You are asked to design a Maximum Availability Solution for a RAC configuration that provides for continuous availability for the Oracle database and which can survive instance failures, node failures, data failures, and site failures. The RAC configuration has a four-node cluster with five different services configured. Performance must be maintained for any failure situation for all the services, and all data must be preserved. All the servers in the configuration will have the same hardware. Which configuration would you recommend? Asymmetric RAC and Data guard configuration with a mixture of RAC and single instances using ASM a tall sites with the same service preferences Asymmetric RAC and a Physical Stand by Data base in a Dataguard configuration with RAC and ASM a tall sites with the same number of instances but different service preferences Asymmetric RAC and a Logical Standby Database in a Dataguard configuration with RAC and ASM at all sites with the same number of instances but different service preferences Symmetric RAC and a Physical Standby Database in a Dataguard configuration with RAC and ASM at all sites with the same number of instances and the same service preferences 4 SC edit delete
33 1Z0-048 Which optional parameter of the DESCRIPTION clause of a TNS entry can you use to make sure that another protocol address is tried if the first one fails? FAILOVER LOAD_BALANCE SOURCE_ROUTE TYPE_OF_SERVICE 1 SC edit delete
32 1Z0-048 After applying a patch to the network device drivers in your operating system, you verify using CRS_STAT -T that everything runs normally. View Exhibit1 for the CRS_STAT -T output. After your coffee break, customers begin complaining about the performance of your Oracle Real Application Clusters database. Suddenly, the response time has increased and establishing new connections is slower than it used to be. You run CRS_STAT -T again to check if there is a problem. Based on Exhibit2, what is your conclusion, and what would you do to correct this? 32-qracm.png There is no problem, so nothing needs to be corrected. You can not tell what the problem is based on Exhibit2, so you can not fix this. Somebody relocated the VIP from the second node to the first node for an unknown reason. You just have to relocate it back The second node in your cluster is down and, therefore, CRS has relocated the VIP from the second node to the first node. After you fix the second node, CRS would relocate the relocated VIP back to its original node. The second node in your cluster is down and, therefore, CRS has relocated the VIP from the second node to the first node. After you fix the problem on the second node, you have to relocate the relocated VIP back to its original node using the SRVCTL command. 4 SC edit delete
31 1Z0-048 You execute the following command from the first node of your cluster: crsctl add css votedisk /dev/raw/raw9 However, you get an error message indicating that Oracle Clusterware stack is not started. Which command would you execute? crsctl add css votedisk /dev/raw/raw9 -force crsctl start crs crsctl add css votedisk /dev/raw/raw9 crsctl start crs crsctl add css votedisk /dev/raw/raw9 -force crsctl enable crs crsctl add css votedisk /dev/raw/raw9 crsctl enable crs crsctl add css votedisk /dev/raw/raw9 -force 1 SC edit delete
30 1Z0-048 Your company asked you to implement RAC to enhance the scalability and availability of the database that you manage. Your coworker suggested that you use ASM as the only storage option. However, you implemented RAC with Automatic Storage Management (ASM) as well as OCFS as storage options. What are the reasons for implementing both OCFS and ASM as storage options? (Choose all that apply.) You want to avoid keeping Oracle binaries on local storage. You do not want to use raw devices to store voting and OCR files. You do not want to store any file other than voting and OCR files in ASM. You want to use the Oracle Managed Files (OMF) feature but that is not supported by ASM. You require OCFS to store archive log files because ASM does not support the sefiles. 1,2 MC edit delete
29 1Z0-048 Which three tools can you use to patch your RAC database? (Choose three.) dbca emctl emca opatch EM Database Control Oracle Universal Installer 4,5,6 MC edit delete
28 1Z0-048 Which statement regarding Clusterware is false? (Choose the false statement.) Oracle Clusterware is installed using the Oracle Universal Installer(OUI). The ORA_CRS_HOME directory must not be the same as the ORACLE_HOME directory. The Oracle Database 10g Clusterware stack is compatible with Oracle 9i Group Services (GSD) processes. The installation of Oracle Clusterware is mandatory even if you have installed vendor-specific clusterware. 3 SC edit delete
27 1Z0-048 Which three statements about Snapshot Control File Management in a RAC environment are true? (Choose three.) You can use a cluster file system or a raw device to store snapshot control files. By default, the snapshot control file is created on the node that is making the backup. RMAN parameters controlling snapshot control files can be configured from the Enterprise Manager Cluster Database home page. You need to configure a default path and file name for these snapshot control files that is valid on every node from which you might initiate an RMAN backup. 1,2,4 MC edit delete
26 1Z0-048 View the Exhibit and examine an installation step of Oracle Enterprise Manager Grid Control 10gR2 to manage your RAC installation. You entered the host name but you are not sure about the port number. The following is the list of port numbers from the host 26-qracm.png 5561 1521 3938 1158 4889 2 SC edit delete
25 1Z0-048 You are considering issues involving backup and recovery of the voting disk. Select four correct statements. (Choose four.) Backup can be performed online. Use symbolic links to simplify recovery of the voting disk. To back up the voting disk, use the command ocrconfig -export. If you lose your voting disk and do not have a backup, you must reinstall Oracle Clusterware. You can determine the voting disks currently used by CSS with the command crsctl query css vote disk. 1,2,4,5 MC edit delete
24 1Z0-048 You are asked to investigate a problem regarding client connectivity between the HR service and a database, which is on a four-node RAC cluster. The HR service has four preferred instances on the RAC cluster. This cluster also supports five other services. Occasionally, a client-connect request for the HR service takes several minutes to connect, whereas the other five services connect within a second or two. Client-side and server-side connection load balancing are used for all the services. Which combination of network settings would explain these symptoms? (Choose two.) The listener on one or more nodes is listening only on the Virtual IP address and the HRTNSNAMES entry uses the Hostnames for the Virtual IP addresses. The TNSNAMES.ORA file has an entry for all six services that uses the host name for the Public IP address and not the Virtual IP address. The listener on one or more nodes is listening on both the Public IP address and the Virtual IP address, and the HR TNSNAMES entry uses the Virtual IP address. The TNSNAMES.ORA file has an entry for the five other services that use the hostnames for the Virtual IP addresses and all the listeners listen on both the Public and Virtual IP addresses. The TNSNAMES.ORA file has an entry for the HR service that uses only the host name for the public IP address, and all the listeners listen on both the Public and Virtual IP addresses. 4,5 MC edit delete
23 1Z0-048 When do you get the first notification after you execute the following command on instance RDBA1? 23-qracm.png when the average elapsed time per call for the ERP service over a 45-minute period exceeds 0.5 seconds when the average elapsed time per call for the ERP service over a 45-minute period exceeds 0.75 seconds when the average elapsed time per call for the ERP service over a 15-minute period exceeds 0.5 seconds three consecutive times when the average elapsed time per call for the ERP service over a 15-minute period exceeds 0.75 seconds three consecutive times 3 SC edit delete
22 1Z0-048 You are creating a database in your RAC implementation. You are using the DBCA to create the database, and you selected the Raw Devices Mapping file on one of the screens of the DBCA. What is the reason for selecting this file? You want the DBCA to bind the partitions to raw devices. You want to set the appropriate raw partition for each database file. You want to configure an ASM diskgroup containing raw devices. You want to provide the DBCA with a list of all the storage devices that are currently bound to a raw interface. 2 SC edit delete
21 1Z0-048 Which four statements contain accurate information regarding RAC VIPs and application VIPs? (Choose four.) ARACVIP fails over if the listener fails. A failed over RACVIP does accept new connections. A failed over application VIP does accept new connections. An application VIP fails over if the associated application fails over. It is recommended to share application VIPs among multiple applications. It is recommended to share a RACVIP among several database instances. It is not recommended to share an application VIP among several applications. It is not recommended to share a RAC VIP among several database instances. 3,4,6,7 MC edit delete
20 1Z0-048 Which three statements regarding backup of the voting disk are true? (Choose three.) On UNIX platforms, the voting disk can be backed up with the dd command. A backup of the voting disk should be taken when ever an RMAN catalog reset is done. A backup of the voting disk should be taken whenever a new node is added to the cluster. A backup of the voting disk should be taken whenever an existing node is removed from the cluster When ever a voting disk backup is made, the Cluster ware software should be stopped on all nodes in the cluster. 1,3,4 MC edit delete
19 1Z0-048 Several steps must be followed to successfully add a new node to your cluster database. Assuming that a UNIX platform is used, which of the three steps below are correct? (Choose three.) Add instances using OUI. Reconfigure listeners for the new node with netca. Configure the OS and hardware for the new node. Add the node to the cluster using the addnode.sh script run from ORA_CRS_HOME Add the RAC software to the new node using addnode.sh from ORA_CRS_HOME 2,3,4 MC edit delete
18 1Z0-048 You are about to build a new Oracle Clusterware-based cluster and you want to make the installation process as smooth as possible. You decide to use the Cluster Verification Utility (CLUVFY) to check whether or not your system administrator has set up the hardware and system software correctly. Which two statements about CLUVFY are true? (Choose two.) You can run CLUVFY only from a privileged operating system account. You can run CLUVFY directly from the Oracle Clusterware distribution media. CLUVFY cannot be used until the Oracle Clusterware is installed successfully. After the Oracle Clusterware installation, you can run CLUVFY from the Oracle Home that holds the CRS binaries. You have to install CLUVFY on all cluster nodes in order to use CLUVFY on other nodes than the one from which you perform the installation. To use CLUVFY during the Oracle Clusterware installation, you have to download CLUVFY from the Oracle Technology Network (OTN) Web site and install it before you can use it. 2,4 MC edit delete
17 1Z0-048 After migrating from a 10g R1 cluster to 10g R2, you decide to multiplex your voting disk. Which are the two ways in which you can accomplish this task? (Choose two.) You should not use symbolic links. You can add additional voting disks online. You must add additional voting disks offline. You may use the VIPCA utility to add new voting disks. You may use the command: crsctl add css votedisk 2,5 MC edit delete
16 1Z0-048 In a RAC environment, you see a steep increase for enq:HW - contention and gc current grant wait events. What would you do to fix this issue? Increase the cache size of sequences. Reduce the time of transactions by committing more often. Use larger uniform extent sizes for objects. Reduce the number of updates causing locks on tables accessed by multiple instances. 3 SC edit delete
15 1Z0-048 You have attended a user group presentation on RAC and based on what you have learned you feel that your company would benefit from having the RAC option to meet its Oracle database requirements in several ways. Your manager does not know much about RAC and asks you to create a presentation to the team explaining RAC, and whether it should be implemented in your installation. Which three statements explain the benefits and implications of RAC? (Choose three.) RAC alone would not help protect from human errors RAC would increase availability in the event of data failures. RAC would increase availability in the event of a network failure. RAC alone would increase availability when doing release upgrades. RAC would increase scalability for all application workloads in all cases. RAC would increase availability in the event of node and instance failures. RAC used in conjunction with parallel execution may provide speedup of DSS queries. RAC used in conjunction with parallel execution may provide for speedup of OLTP workload processes. 1,6,7 MC edit delete
14 1Z0-048 Your company has certain standard practices for technology and you are configuring ASM disk groups for your four-node RAC cluster. The company guidelines suggest that there is one disk group for the flash recovery area that is shared by all databases and a separate disk group for the database area of all databases. Which three exceptions exist that may require you to create additional disk groups? (Choose three.) The retention policy for backups are different for different databases. There are large non partitioned tables accessed frequently using indexes. The disk farm has different disk models with different characteristics and ages. Some databases operate in ARCHIVELOGMODE and others in NOARCHIVELOGMODE. Some data base instances are shutdown every night while others are always running. Applications using the databases have different Service-Level Agreements for response time and throughput. There are partitioned tables where the older partitions are in read-only table spaces and seldom accessed, but the more recent partitions are frequently accessed 3,6,7 MC edit delete
13 1Z0-048 You decide to implement a Data Guard configuration to support a disaster recovery plan for your RACdatabase. Your primary database has all shared files and the flash recovery area is stored on ASM disk groups. Which three options exist for storing the data guard broker configuration files at the primary location? (Choose three.) can be in any shared ASM disk group can be stored on shared Raw Devices must be stored on Oracle Cluster File System if a cluster file system is used may be stored on any supported cluster file system if a cluster file system is used must be in the same shared ASM disk group as the database data files if the broker configuration files are stored in ASM disk groups must be in the same shared ASM disk group as the Flash Recovery Area if the broker configuration files are stored in ASM disk groups. 1,2,4 MC edit delete
12 1Z0-048 Your company has a combination of high availability and scalability requirements that need to be addressed, and RAC has been discussed as a solution. There are a mix of "off-the-shelf" software products and homegrown applications currently in use in your environment that run on single-instance Oracle databases. You have been asked by the IT director to provide an impact analysis report to help assess the impact on applications when migrating to RAC. Which three are among the areas that should be examined for performance impact and application functionality impact or for both? (Choose three.) applications that use large parallel full table scans applications that truncate tables in a data ware house process three-tier applications that use application global context variables client/server type applications that use application local context variables applications that access small tables using the same index occasionally applications that use SQL profile screated by the ATO optimizer in the SQL Tuning Advisor 1,2,3 MC edit delete
11 1Z0-048 Which two initialization parameters must be set to start up an ASM instance in a RAC environment? (Choose two.) INSTANCE_TYPE DB_UNIQUE_NAME ASM_DISKSTRING ASM_DISKGROUPS ASM_POWER_LIMIT CLUSTER_DATABASE 1,6 MC edit delete
10 1Z0-048 Oracle Cluster Registry (OCR) can be recovered on a UNIX platform using which two commands? (Choose two.) ocrconfig-import/u01/logical_ocr/yesterday.ocrwhereyesterday.ocr is an automatically generated OCR backup ocrconfig-import/u01/logical_ocr/yesterday.ocr_expwhereyesterday.ocr_exp is a logical backup created using the ocrconfig -export command cp /app/oracle/product/10.1.0/crs_1/cdata/dbclust01/day.ocr /ocfs/OCR/crs.dbf where /ocfs/OCR/crs.dbf is the cluster registry file ocrconfig -restore /app/oracle/product/10.1.0/crs_1/cdata/dbclust01/day.ocr where day.ocr is an automatically generated OCR backup 2,4 MC edit delete
9 1Z0-048 After the cluster database has been successfully created, several postinstallation tasks should be completed. Identify three of them. (Choose three.) Create the ASM instance. Backup the root.shscript. Initialize the cluster backup procedure. Set up additional required user accounts. Verify the Enterprise Manager/Oracle Cluster Registry configuration by running srvctl config database-d db_name. 2,4,5 MC edit delete
8 1Z0-048 Which three storage types are suitable as a flash recovery area for an Oracle 10g RAC database? (Choose three.) Raw volume ASM disk group Local file system Cluster file system Shared NFS directory 2,4,5 MC edit delete
7 1Z0-048 View the Exhibit, which displays the cluster database performance page after the same workload has been executed three times on your cluster without varying any non-Oracle workloads on the cluster. What are the two ways by which you can tell that the corresponding application was better tuned during the second and third execution? (Choose two.) 07-qracm.png There is less paging each time. The run queue length is going down each time. It takes less time to execute the workload each time. The number of transactions per second is getting higher each time. The database through put graphic is below the red dashed line during the last execution 3,4 MC edit delete
6 1Z0-048 After a power failure, you noticed that one of your cluster database instances did not start automatically, whereas all other instances came up successfully. What would you do to determine the precise cause for the instance startup failure? (Choose three.) Check the resource state by using the CRS_STAT command. Check for OCR corruptions by using the OCRCHECK command. Check the alert.log file that belongs to the instance that did not start. Check the alert.log file that belongs to the Oracle Clusterware software. Check if the Oracle Clusterware is functional by using the CRSCTL command. Reboot the node where the failing instance reside stocheck if the problem is persistent. Enable extra debugging in the Oracle Clusterware software by using the CRSCTL command. 1,3,4 MC edit delete
5 1Z0-048 You have a well-tuned, non-RAC single instance Oracle database with several services, all of which perform perfectly. You plan to migrate the database to RAC in the next two weeks and all file systems would be shared using Oracle Cluster File System. After the migration, you want to perform a test to monitor RAC-specific tuning issues that would not have occurred on a non-RAC database. Which six areas would you monitor to determine whether there are RAC-specific performance problems after migration? (Choose six.) Interconnect latency Instance recovery time Services with applications that use external tables Services with applications that truncate large tables Services with applications using local context variables Services with query-intensive applications relying on full table scans Services with insert-intensive applications that use Oracle sequences for index keys Services with applications that have occasional queries, using index access on modestly sized tables Services with insert-intensive applications that generate their own keys without Oracle sequences 1,2,4,6,7,9 MC edit delete
4 1Z0-048 Which initialization parameter would you use for each RAC instance to make sure that each listener on each RAC node is aware of the load of all the others? LOCAL_LISTENER REMOTE_LISTENER REMOTE_DEPENDENCIES_MODE PREFER_LEAST_LOADED_NODE_ 2 SC edit delete
3 1Z0-048 You are running a two-instance database with six redo log groups defined and decide to add a third thread to support a third database instance on the third node of the cluster. Which three commands would you issue to achieve this using command line administration? (Choose three.) ALTER SYSTEM ENABLE THREAD 3; ALTER DATABASE ENABLE THREAD 3; ALTER SYSTEM ADD LOGFILE THREAD 3 GROUP 8; ALTER SYSTEM ADD LOGFILE THREAD 3 GROUP 7; ALTER DATABASE ADD LOG FILE THREAD 3 GROUP 7; ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 8; 2,5,6 MC edit delete
2 1Z0-048 You are working as a DBA in a RAC environment that is available for testing. The RAC environment has all the database files stored in the OCFS file system. You plan to install ASM and move all the database files to ASM to achieve better performance. During the installation, you selected redundancy level as normal for the disk group being added. What is the reason for selecting this redundancy level? You want to use hardware mirroring. You do not want to have any mirroring in the diskgroup. You have two failure groups defined, so you want to use two-way mirroring. You have three failure groups defined, so you want to use three-way mirroring. 3 SC edit delete
1 1Z0-048 Which optional parameter of the DESCRIPTION clause of a TNS entry can you use to randomize the access to available listeners? FAILOVER LOAD_BALANCE SOURCE_ROUTE TYPE_OF_SERVICE 2 SC edit delete

Copyright © Designed & Developed by Sakthi Db Technology 2018